package com.practice.springboot_01_zwj.mapper;

import com.practice.springboot_01_zwj.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface ThreeHundredMapper {
    @Select("select * from gzt_three_hundred")
    public List<ThreeHundred> selectThreeHundredAll();

    Map<String,Object> selectThreeByCityCode(@Param("cityCode") String cityCode,@Param("yearFilter") String yearFilter);
    Map<String,Object> selectThreeByProvinceCode(@Param("provinceCode") String provinceCode,@Param("yearFilter") String yearFilter);
    List<ThreeHundred> selectProvinceCodeAll(@Param("provinceCode") String provinceCode, @Param("hundred") ThreeHundred threeHundred);
    List<ThreeHundred> selectCityCodeAll(@Param("cityCode") String cityCode, @Param("hundred") ThreeHundred threeHundred);

}
